package com.freshfresh.view.db;
/**
 * 创建表SQL类
 * @author Administrator
 *
 */
public class TabSQL {
	
	/**
	 * 我的收藏
	 */
	//	商品id  product_id
	//	商品图片 picurl
	//	商品名称 name
	//	现货        stock
	//	商品价格 price
	//	商品数量 count
	public static final String SHOPPINGCAR = "create table fresh_shoppingcar("
			+ "_id INTEGER PRIMARY KEY AUTOINCREMENT," //主键
			+ "product_id TEXT  NOT NULL,"
			+ "picurl TEXT  NOT NULL,"
			+ "name TEXT  NOT NULL,"//
			+ "stock TEXT  NOT NULL,"
			+ "price TEXT  NOT NULL,"
			+ "count TEXT  NOT NULL"//
			+ ")";
	
	
}
